package cn.edu.zjgsu.ito.model;

public class AdminCourseManageModel {
	public static AdminCourseManageModel dao=new AdminCourseManageModel();
	public String lookMajorSql="select * from major";
	public String lookCourseSql="select * from course";
	public String lookClassroomSql="select * from classroom";
	public String lookStudentSql="select * from student_info where studentStatus=?";
	public String lookTeacherSql="select * from teacher_info";
	public String insertStuTimetableSql="insert into student_timetable(passportNo,termValue,courseNo,courseName,tNo,tName,classroomNo,startLesson,endLesson,startWeek,endWeek,whichDay,uuid) values(?,?,?,?,?,?,?,?,?,?,?,?,?)";
	public String insertTeaTimetableSql="insert into teacher_timetable(tNo,termValue,courseNo,courseName,classroomNo,startLesson,endLesson,startWeek,endWeek,whichDay,uuid) values(?,?,?,?,?,?,?,?,?,?,?)";
	public String studentConflickSql="select * from student_timetable where passportNo=? and termValue=?";
    public String studentConflickSql2="select * from student_timetable where passportNo=? and termValue=? and uuid!=?";
	public String lookTeaIdSql="select * from teacher_info where tName=?";
	public String teacherConflickSql="select * from teacher_timetable where tNo=? and termValue=? and uuid!=?";
	public String lookClassroomByOptionSql="select * from classroom where classroomNo=?";
	public String classroomConflickSql="select * from major_timetable where classroomNo=? and termValue=? and uuid!=?";
	public String updateClassroomStatusSql="update classroom set status=1 where classroomNo=?";
	public String updateStuTimetableSql="update student_timetable set whichDay=?,startLesson=?,endLesson=?,startWeek=?,endWeek=?,tName=?,classroomNo=?,tNo=? where uuid=?";
	public String updateTeaTimetableSql="update teacher_timetable set whichDay=?,startLesson=?,endLesson=?,startWeek=?,endWeek=?,classroomNo=? where uuid=?";
	public String updateMajorTimetableSql="update major_timetable set whichDay=?,startLesson=?,endLesson=?,startWeek=?,endWeek=?,tName=?,classroomNo=?,tNo=? where uuid=?";
	public String lookStudentBypassportNo="select * from student_info where passportNo=?";
	public String insertRosterSql="insert into roster(tNo,termValue,courseNo,courseName,sNo,passportNo,lastName,firstName,majorNo,majorName,uuid) values(?,?,?,?,?,?,?,?,?,?,?)";
	public String insertMajorTimetableSql="insert into major_timetable(termValue,majorNo,majorName,courseNo,courseName,tNo,tName,classroomNo,startLesson,endLesson,startWeek,endWeek,whichDay,uuid) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
	public String lookmajorTimetableSql="select * from major_timetable where majorNo=? and termValue=?";
	public String lookcourseNoSql="select * from course where courseName=?";
	public String lookmajorNoSql="select * from major where majorName=?";
	public String judegRosterSql="select * from roster where tNo=? and termValue=? and courseName=?";
	public String deleteTeacherTimetableSql="delete from teacher_timetable where uuid=?";
	public String deleteStudentTimetableSql="delete from student_timetable where uuid=?";
	public String judegTeacherTimetableSql="select * from teacher_timetable where tNo=? and termValue=? and courseName=?";
	public String deleteRosterSql="delete from roster where uuid=?";
	public String deleteMajorTimetableSql="delete from major_timetable where uuid=?";
	public String lookmajorNameSql="select * from major where majorNo=?";
	public String lookCourseNameSql="select * from course where courseNo=?";
	public String lookCourseStuInfoSql="select * from student_timetable where uuid=?";
	public String lookCourseTeaInfoSql="select * from teacher_timetable where uuid=?";
	public String lookmajorTimetableByOptionSql="select * from major_timetable where uuid=?";
	public String lookCourseStuByUUIDSql="select * from student_timetable where uuid=?";
	public String updateStuTimetableByPassportSql="update student_timetable set whichDay=?,startLesson=?,endLesson=?,startWeek=?,endWeek=?,tNo=?,tName=?,classroomNo=? where uuid=? and passportNo=?";
	public String deleteStudentTimetableBypassportSql="delete from student_timetable where uuid=? and passportNo=?";
	public String lookCourseTeaByUUIDSql="select * from teacher_timetable where uuid=?";
	public String updateTeaTimetableByTNoSql="update teacher_timetable set whichDay=?,startLesson=?,endLesson=?,startWeek=?,endWeek=?,classroomNo=? where uuid=? and tNo=?";
	public String deleteteacherTimetableByTNoSql="delete from teacher_timetable where uuid=? and tNo=?";
	public String lookCollgeSql="select * from major where majorName=?";
	public String lookCollegeSql="select * from college";
	public String lookCourseByCollegeSql="select * from course where collegeCode=?";
	public String lookTeacherByCollegeSql="select * from teacher_info where collegeCode=?";
	public String lookClassroomByTypeSql="select * from classroom where classroomType=?";
	public String lookStudentByDateAndMajorNoSql="select * from student_info where eduStartDate=? and majorNo=? and studentStatus=?";
	public String lookStudentByDateAndMajorNoSql1="select * from student_info where majorNo=? and studentStatus=?";
	public String lookStudentByDateAndMajorNoSql2="select * from student_info where eduStartDate=? and studentStatus=?";
	public String lookTermSql="select * from term order by termValue desc";
	public String addTermSql="insert into term(termValue,invalid,current) values(?,?,?)";
	public String deleteTermSql="delete from term where id=?";
	public String lookCurrentTermSql="select * from term where current=?";
	public String updateCurrentSql="update term set current=0 where current=?";
	public String setCurrentTermSql="update term set invalid=0,current=1 where id=?";
	public String setInvalidTermSql="update term set invalid=1,current=0";
	public String lookStuGradeNo="select * from student_grade where uuid=?";
	

}
